Login Register |
|
|
|
|
 |
CF Debug Enhanced
Project Home • Blog • Forums • Screenshots • Contact Project
Author: Ajas Mohammed (All RIAForge projects by this author)
Description:
The classic.cfm template for debugging comes with basic information. I have enhanced it with new features like SQL Query ResultSet, Stored Procedure ResultSet, and more importantly, returning the values of ALL OUTPUT parameters in a stored procedure call. This will help developers to see the values instead of running the stored procedure in Query Analyzer or any editor.
Summary 1. returns result set of a query 2. returns result set of a stored procedure. Actually returns *all* result sets from a stored proc 3. returns procedure name, procedure resultset name like this SQL Name : Q_Get_Info --- CFPROCRESULT Name : rs_results --- RESULTSET No : 1 4. returns the values of output variables of stored procedure. Please note that in some cases i.e. huge query resultset, this might increase processing time to render page (because of resultset from a query etc), so use it in development or quick troubleshooting in production. Have a look at screenshots for more information. The idea behind developing this was to allow the debug template give as much information as possible, so the programmer's don't have to copy query and run it in Query Analyzer or any editor to see the results returned. Plus, if you had lot of OUTPUT variables returned by stored procedure, you would have to create variables in query analyzer. With this template, you get the best i.e. results of output variables as well. Also, no more cfdump statements inside your code for seeing results from a query.
Requirements:
ColdFusion 7/8/9. I have not tested this on versions 6 and 8 but I believe it should work.
Install : Copy the cfm template to the appropriate debug directory. On CF9 it is C:\ColdFusion9\wwwroot\WEB-INF\debug and CF7 it is C:\CFusionMX7\wwwroot\WEB-INF\debug If you have multiserver installation (also called multiple instances), then the location for debug template is C:\JRun4\servers\your_instance_name\cfusion.ear\cfusion.war\WEB-INF\debug Go to CF Administrator, under debug templates, select the cfm file downloaded from riaforge site and hit submit. |
Adobe and the Adobe product names are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries.
